Release 10.1A: OpenEdge Development:
Basic Database Tools

Schema menu

The schema of the database is the definition of its structure: the tables it contains, the fields within the tables, sequences, etc. In addition to database structure, schemas contain validation expressions and validation messages.

Use the Schema options to add, update, or delete table, field, index, or sequence definitions. Table 9–1 lists the Schema menu options and gives a brief description of each. More detailed descriptions of the options follow the table.

Table 9–1: Schema menu 

Schema
Modify Table...	Changes information defined for an existing table.
Add New Table...	Creates a new table definition.
Delete Table(s)...	Removes one or more table definitions.
Field Editor...	Adds, alters, or removes fields from a table definition.
Reorder Fields...	Resequences the fields into alphabetical order, or resets the order numbers of the fields.
Global Field Name Change...	Changes a field name throughout the database.
Index Editor...	Adds, alters, or removes indexes in a table.
Sequence Editor...	Adds, alters, or removes sequences in a table.
Adjust Field Width...	Alters field width value in a table.